SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35684 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35684 [ RunTime:0.003803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353161,742851,219414,754740,454866,212031,289247,651884,649599,265347,951360,299307,244764,191136,765056,876305,1030163,492540,249920,914844,948113,79416,753276,885169,487465,787829,870336,124561,132538,850914,651109,263664,1028266,550519,3038,637500,176837,787677,481455,49905,648150,381092,437777,244809,133283,1025932,721651,291388,199849,882283,365040,967300,704216,792533,936319,447955,578479,737758,363031,542652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]