SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34103 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34103 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281176,71992,626687,123601,954227,752217,87921,280932,35501,1036698,920838,980558,661630,875973,68094,670488,976883,69424,297311,168037,190747,630943,948858,841419,970597,812259,154259,404936,404381,830868,787786,205960,604332,441556,620451,554915,521914,450025,564722,526418,712401,784330,116727,17578,316141,169045,147170,594885,341384,838114,655001,900990,210032,415967,981236,402000,616674,933824,625288,570018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]