SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451498 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451498 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118133,822240,1030997,967233,913330,680156,769471,379208,556561,766754,151629,125900,97977,1038217,503812,614849,552264,76501,279878,691942,842101,165016,667933,299291,79658,946475,919875,121171,249959,219441,788697,8558,133204,497697,585947,58189,434947,1033537,1033429,928090,674985,246219,196772,356686,670675,94837,592059,538799,232502,115899,945436,500883,725563,783051,507842,401691,485103,270002,919169,495389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]