SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342418 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342418 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875148,969339,785238,20182,337842,1016786,785481,14223,460068,970896,1007516,244911,146275,335477,436020,692407,639811,905713,818646,423554,479724,291905,810838,306427,535562,824821,613740,977818,526851,784787,61460,317089,338947,195737,665558,102950,226301,806465,327856,627399,45535,457407,1015930,40187,146730,213409,977647,813233,767005,779554,581270,43858,503847,366491,590172,929543,906029,529995,874031,803834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]