SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245080 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245080 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638270,926947,950795,428367,1031225,559473,792748,104141,268391,60436,462772,180006,141364,336215,797216,987966,81107,196879,510634,608520,1007762,359444,660374,23891,633334,365361,1003663,947441,809518,101827,35954,1034856,616618,763806,751468,667219,176110,202873,676185,229871,988658,498460,572934,37468,807780,680813,814000,80217,935083,689255,431208,826591,1013787,366480,49731,529942,477289,937758,509339,212955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]