SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 938013 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 938013 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464699,294496,77592,791068,433891,303768,827374,419714,581554,174968,795437,990195,132674,16341,945646,838157,558897,443487,367911,459464,899483,296072,421545,188887,239167,308495,116788,860426,518387,84863,152590,232874,1031660,717921,945053,332612,911899,786940,581050,278180,18730,615263,151946,907790,389792,774786,160262,889222,778812,754212,794580,822316,264973,207392,485641,633566,439177,957253,1008022,138814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 938013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 938013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]