SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481241 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481241 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884198,646170,1018726,806666,121148,289929,382558,540478,994736,153363,919397,572629,362214,9914,653498,233717,596455,154211,373567,191785,154017,295254,605628,583687,801618,437300,516030,219710,354655,777627,1012655,807146,408564,707684,520777,178221,37358,443290,925707,402912,720301,142466,707450,205763,842578,683332,169254,680838,576996,406954,337453,112727,310257,190826,390700,575606,296872,351865,341665,267809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000943s ]