SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 741022 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 741022 [ RunTime:0.002595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581021,641114,244715,714402,281812,282888,613202,770402,996070,374997,982603,733017,931207,901221,460250,946044,850353,114436,462327,925890,554682,852110,378261,954699,8957,702585,419482,692253,88666,539754,1012838,545449,475375,208540,979027,206429,838779,1031351,607012,421144,924132,213918,897986,352883,934090,356304,157890,739871,870392,49911,671287,210711,348835,925881,278438,409682,896536,408096,1021673,773688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 741022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 741022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001191s ]