SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598418 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598418 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544267,905633,797500,996786,1028545,272211,417948,933633,646991,676121,742916,661994,795380,195540,159312,1020117,325108,98480,21206,414681,898913,450280,995471,252046,403770,954707,258654,866854,635796,568593,649939,269186,117823,1030494,455736,788109,564753,820015,424262,391305,32102,183074,433541,66898,503864,199949,781697,11847,1046760,605176,683573,754849,133634,477494,716931,100794,712020,194598,463360,572938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]