SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311034 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311034 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402852,13694,295459,789611,131411,559004,94792,343380,994392,242780,767942,959880,995712,21657,390726,746871,872773,664407,1005730,592752,35654,965279,392857,368601,1023318,242947,547943,962788,508068,20273,778150,781001,276557,991267,19293,40824,895762,338476,343214,868446,733278,366400,756015,402888,441189,572107,689976,373307,363124,21263,819485,262058,845549,687087,123505,423812,141219,652511,340610,384741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]