SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28040 LIMIT 1 [ RunTime:0.001505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28040 [ RunTime:0.003049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521779,74156,431158,293831,33160,1045684,736530,1009285,192869,350048,102666,841654,208290,814206,652419,133516,677599,116770,298834,14219,890802,551967,92641,57522,527721,948647,296685,1047633,736997,537290,338777,912469,410568,152119,595292,10707,229452,596530,591555,1043146,141238,518594,34657,741631,174740,222654,238008,804564,190988,513673,755670,486524,440921,878819,1123,968900,77334,743122,112136,439305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001168s ]