SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351203 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351203 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512147,997828,557461,840726,257962,945962,1000626,616287,952695,1024529,155263,560844,363673,352913,148047,1012833,356118,736272,728563,126095,488948,488182,636101,543639,805201,335436,344887,264208,684477,200974,924586,366077,225551,486191,603857,1010143,707481,481733,778472,106625,572679,401379,905511,372938,754138,285537,749514,142095,334321,846934,16606,79674,249649,344446,1004851,509476,831682,529387,314405,529928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]