SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327907 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327907 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951276,782694,95123,15634,945417,470602,170494,1013224,233331,120012,1011722,982071,112697,778606,983308,37971,924798,820208,605108,192734,272172,942114,106107,408704,21154,142119,179959,499570,724616,314893,691351,858939,590513,34914,675818,294221,410919,853869,39733,127288,616653,229214,110843,545957,505792,209820,951811,523246,302290,254023,560846,461172,1029069,991295,661813,656015,213927,184788,250895,438778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]