SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342313 LIMIT 1 [ RunTime:0.001075s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342313 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046703,189565,967632,659575,181131,59121,555785,832886,395215,1009733,301959,64242,435977,1026353,701273,255826,285229,227109,833727,324392,136569,998469,329458,836478,932113,426616,295354,391650,682012,143767,817836,725404,964588,1004543,806448,720675,95621,678880,735673,104205,1013007,498454,1011789,322957,952260,456410,699185,781825,19996,309030,223434,902119,624083,900920,1004558,375465,65241,993129,115863,559611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001295s ]