SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554326 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554326 [ RunTime:0.008657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584881,840040,676721,898876,731494,166654,444390,547310,877934,458272,720467,108280,163141,788942,225060,745155,17050,60606,321936,97486,449289,408686,543470,1028524,712923,296505,751888,792665,192983,424526,237491,724532,315813,265384,168903,123092,499579,469997,1002327,284369,973682,503942,790994,459582,926132,470804,397007,415456,479887,481387,768134,518125,841880,400078,775432,450649,505384,245884,80443,438524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002314s ]