SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56140 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56140 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470461,382299,282545,1033199,651805,264090,425961,263847,956442,819492,654037,959650,839322,429485,31854,56629,707323,572856,66358,843305,931377,618892,868939,812978,776053,1034048,130466,40203,240265,100241,464339,89634,823242,698516,298545,428547,230520,772462,332701,243617,316825,583017,266180,716840,832132,451113,855535,24771,78281,786009,586299,700949,979537,519051,130107,907210,363682,543931,768973,396477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]