SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407871 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407871 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745793,984450,581930,1029,141755,694278,64334,159486,378663,841586,828043,1017529,406948,975304,273727,734066,97346,12455,737780,836960,569338,470665,251630,212139,36427,297418,63875,757853,276356,233834,980975,230390,527064,593598,463504,873267,990283,750682,162266,562114,58987,765746,432823,309935,910526,506380,713950,77675,973984,1000430,300406,836792,1020041,455587,907956,289335,298907,831326,110756,904755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]