SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4438 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4438 [ RunTime:0.004416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349343,237348,93085,464098,748901,904047,101393,800270,649649,1022490,814772,725885,408328,303194,149362,691682,559875,58659,439804,825192,734907,298474,96413,827718,465102,387832,777943,160325,487046,29765,66203,704549,359185,815314,444561,21978,344672,851148,361053,272772,518088,1048426,901106,261059,115831,672881,498499,155611,985737,259317,992909,226821,690115,943139,451142,699704,303438,586866,529031,524637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]