SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109310 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109310 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412430,827262,1019576,681254,219458,461429,319167,142544,445365,296500,94128,633712,485842,692182,422601,736696,172568,348278,1011460,920941,198569,699697,132781,240999,140828,738884,176526,880502,539595,907000,698711,255795,147499,178709,502622,987219,153918,166172,824737,330187,377469,256593,46312,648353,47838,988081,310722,801761,679181,67451,114261,1048850,87247,615965,176177,562608,525517,1042611,50637,920727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]