SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295404 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295404 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809076,672964,233285,301595,969751,395201,482723,509109,142500,691611,882682,332275,1003986,518404,666270,680788,736340,665586,282377,178594,621088,622962,842263,309918,962737,374007,260777,394085,351036,363520,444891,781095,30449,603852,250698,707009,537956,138500,917551,238412,1021048,317551,279191,199825,895623,218869,95151,731200,75976,79338,793911,63290,911084,489008,856148,142478,701662,903665,445798,678838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]