SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345281 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345281 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734286,710653,495455,300832,241558,21755,872937,258037,760184,408499,744136,1045564,972724,150334,481341,556175,233887,506215,1018352,923769,349255,320762,390342,927444,820188,848745,184191,821606,826549,805111,506492,883279,14604,531104,886606,819757,881832,94616,709673,540814,333498,1011479,406663,572298,861130,702018,754781,903769,291628,540780,593853,210359,219052,325921,629578,911055,901108,5203,281099,641337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003216s ]