SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502872 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502872 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947329,274928,379376,504201,177707,482855,66944,294560,193047,65674,209068,167186,176591,251167,147716,58021,476467,683374,580454,800615,2215,497327,462536,401244,550848,982700,575500,117550,355107,401978,151982,887805,515862,555109,532899,613480,96640,528668,567489,706817,955585,308849,1024461,553357,247163,703837,231754,223529,28775,701679,768634,139061,893110,437541,667679,1025695,741283,960005,506042,900177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]