SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422801 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422801 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760599,331653,235537,861050,475870,859635,276610,781078,195373,167311,546327,489020,639777,329971,890268,603008,775106,490692,270444,454042,514043,256524,1018672,206582,753864,114444,168537,510672,355496,866503,744433,46236,295902,228524,816280,70823,1024784,810953,175324,357852,48731,863715,630134,690099,835607,602961,935402,635100,997079,223752,891016,937567,112933,339756,974803,509745,50095,835970,553697,1036899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]