SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286307 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286307 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498035,1031359,513835,737185,692727,957830,530181,745271,615802,375428,459075,452663,269379,132033,572105,330317,426795,814710,169110,974002,1016050,783636,362598,387453,658133,950044,433187,250377,615197,939501,562890,667505,270985,416448,544204,943389,880064,193802,974348,27048,499810,980312,842614,256145,250489,797529,63392,994129,662049,51995,152221,504791,113820,622905,492561,296608,91451,583451,660020,390959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003962s ]