SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193464 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193464 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272037,781982,113644,378562,545015,502230,536423,97968,543268,836836,55643,706917,874338,257500,102501,650454,733447,879637,592217,515780,637316,1024001,1025997,152251,934445,492798,269626,467853,651559,1032158,865779,122750,821995,923714,727972,46689,637031,329267,128457,846265,340832,351028,836915,615325,799381,435734,539965,817869,261868,89207,58862,482299,427173,397976,76454,218222,652696,685339,440253,376479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]