SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040213 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040213 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789927,183111,708406,913246,635882,690313,5645,672986,847431,529628,581121,604212,136970,305849,205369,432427,281781,938631,736318,826638,369891,198348,728338,233679,239402,1024801,554385,555197,861163,699773,312477,606980,403434,53807,516949,48387,643073,392565,104220,143351,69802,615524,303371,715822,421463,255027,861351,206033,593877,172047,1000867,151516,493337,293845,480909,188491,506369,564261,539877,208479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]