SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521114 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521114 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924071,736653,218015,590176,45297,948393,464006,753715,621128,647174,591013,261174,238042,805300,344843,634497,354314,744595,10554,589950,5419,215752,558937,751614,683349,428355,123081,1122,556615,408430,33167,337271,807459,770521,468083,559324,412220,41315,682014,902239,696995,597539,881926,377676,95586,860344,211853,154128,945180,175255,559193,780400,372695,941830,490581,388686,73992,89504,866457,363510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]