SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521579 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521579 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956644,536100,820330,811468,903036,638995,247848,773413,1044416,111434,361948,914142,974756,626313,508757,466067,703239,108993,999111,50697,662987,608454,517135,372962,503011,529573,950204,146383,136551,866424,535607,1023324,782317,305720,196699,374030,297756,435885,34751,165542,27930,650259,426203,782021,841039,977132,260797,514092,859177,31599,995222,166639,530293,42402,364816,1021880,505359,372756,781354,885773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]