SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283091 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283091 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717130,211694,854971,728468,923710,378592,16652,971573,872938,646783,612083,476801,779837,647728,232442,798121,967593,76904,677388,1042410,39310,971764,182495,147337,929537,740219,673545,952645,54838,647312,520301,583680,747676,609999,303767,491112,404337,399957,330027,768477,499973,634287,962840,842644,160733,778221,110541,771330,875935,497469,348698,701137,527920,802737,767774,306119,474013,236449,307559,720667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001186s ]