SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108591 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108591 [ RunTime:0.003050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789294,947604,878242,677484,813723,707303,685339,714562,382299,513761,687182,248411,290295,286564,1005299,367386,1022340,38237,844155,481845,215774,701305,849343,114508,533266,552367,965794,232132,863311,987269,989938,496437,671791,498309,676299,580397,231215,648353,199930,964334,619040,541469,441054,111326,535840,926842,578808,1000604,495146,835034,461753,617578,744382,152986,962300,847315,376830,649371,122201,741670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]