SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597704 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597704 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119144,713042,43434,1045928,94054,379061,28804,149811,561370,422110,111577,634241,767280,1011044,919265,226474,802321,969432,794991,128030,813688,586492,117077,140297,874055,851397,406485,632299,905976,829027,917593,116770,523480,139467,262697,583173,674292,297541,651711,251027,828971,771246,454441,965614,736590,740128,1040727,408093,140046,220590,904035,398331,673569,665379,145140,824219,96858,1046160,520499,724268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]