SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 930141 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 930141 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100446,982023,37679,862517,13238,149083,831832,1000202,676300,425454,124217,221302,526671,789370,740002,871081,116362,409312,31187,961553,608401,253413,320572,334833,444639,985216,483737,799565,585615,445626,49160,32223,211582,283,168252,637381,41569,788845,146005,561887,559144,316800,688008,303631,831231,69573,512552,372054,684057,767799,51749,700453,756019,329881,412162,44962,186389,138572,449550,12389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 930141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 930141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]