SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 647404 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 647404 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460576,282329,211106,524444,529001,786527,85371,150826,784859,45176,143057,789820,881066,607701,71356,282940,911055,293226,251936,44471,571241,651886,981970,810220,47509,768497,261684,127513,569785,805072,610447,217580,1039604,872026,485702,962806,969500,1017360,819367,495739,193800,868204,293060,636274,995379,1012245,313258,160086,365109,1006212,385226,933032,614281,256096,952186,233074,166445,158971,1009899,361040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 647404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 647404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]