SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10605 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10605 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57957,722943,179035,675715,954814,496871,654502,881791,710743,860967,232649,625231,588159,792331,276436,377711,718386,349824,912082,79970,656412,176812,781172,543973,734118,181390,708052,952976,860150,189362,482539,527217,1024243,307920,171354,1044725,683261,58571,422647,809286,178446,679407,941560,576284,90059,433108,76050,724204,414584,19430,526978,179791,1025788,172452,440854,339427,227923,713165,21015,58294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]