SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 638703 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 638703 [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519983,17398,1036183,167087,234190,181711,355088,307759,529607,695510,900477,156047,631623,106050,138555,48526,494393,141122,911600,283806,979757,649538,11216,62732,705245,944519,727964,487406,162889,1006080,589593,485469,703543,260855,1037772,94248,526930,793571,751670,838989,468004,934935,418659,8562,987304,749159,673077,102563,397400,42712,578312,1033960,1005941,574102,711343,345137,252105,68312,210768,341622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 638703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 638703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002426s ]