SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 944362 LIMIT 1 [ RunTime:0.003657s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 944362 [ RunTime:0.007833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919184,315683,314533,976212,255291,793726,900584,499944,442560,274476,572692,111739,786750,230839,748135,1045898,31852,629395,995189,816396,858351,794012,705044,77027,889517,979974,866016,262686,384325,1019519,708885,295382,127673,971946,750043,48571,875551,1004912,24745,349860,161881,399204,203450,762834,914078,347919,147540,365891,644951,590854,422279,55597,288615,643091,596653,360966,756648,702857,891888,796192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 944362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 944362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]