SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529611 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529611 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905491,174289,102221,747232,1045673,431773,956960,766118,1042879,1037527,637212,662932,986018,116366,896223,101696,191659,154844,938910,391968,276939,841442,931863,425978,432260,176259,134089,583288,202986,519801,816599,254657,691014,666431,756998,419855,598255,938298,112576,1015897,586716,1005674,806837,879975,798960,245584,718451,915371,901832,798180,237701,530203,859939,99450,644703,50533,1032697,593037,467283,541069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]