SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506025 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506025 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030944,378883,211101,783756,915038,859316,67194,646073,1015678,392923,133436,449856,115666,214430,793275,217971,624338,340005,835788,535511,1018426,834319,1042059,589574,921037,865955,138366,348672,404206,359653,35441,804063,676381,910556,46248,294270,729328,921744,827921,425580,778681,663919,862537,598609,88379,971665,161260,152063,850544,920122,208195,76953,198588,480401,762678,99905,897016,794434,866876,980070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]