SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291457 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291457 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011814,639772,842981,145819,885499,341540,1000777,481269,99138,724705,276223,744250,742130,618480,717962,83029,337680,116308,18076,931602,1046308,21046,366102,407417,489439,954106,922761,366315,807405,783047,950424,97512,916066,863594,669107,68019,846951,238537,731492,428592,301039,167049,53980,571642,1033824,31252,870129,840051,557853,1019419,205085,1040768,460855,331382,54332,270480,587633,428646,454243,114300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]