SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287640 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287640 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891150,146480,841523,193099,563669,81393,253073,988298,627684,204734,664560,175425,551793,971378,873305,418858,538108,70748,90749,617951,980846,320371,984271,1004675,256275,645506,12015,884196,981344,272315,470782,265095,982790,538366,237163,908469,123621,897230,84435,731917,667359,992777,313609,936109,1029479,886278,45001,588348,684430,787300,218181,302491,329718,523322,175754,177754,652641,240195,1032593,518667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]