SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316421 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316421 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003797,1023789,620963,247521,98194,404611,491867,546541,1035814,925413,392614,196080,623122,702136,189047,827392,123211,101933,546222,411342,383083,979409,983922,779050,845965,382774,52438,554600,683814,19478,286935,340456,5414,592239,186667,261278,2492,588226,433381,761911,530736,433476,363071,128434,197169,769826,157241,745544,595342,530579,962576,112155,192778,564427,423832,232172,830598,27040,182795,20287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]