SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336571 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336571 [ RunTime:0.002557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515069,109865,1020241,793677,821748,1039506,968750,230119,125965,183328,190612,636738,52536,485672,408033,100047,966515,487132,971968,122723,629300,695279,394744,225970,579123,761337,757881,722062,156351,721476,639358,219788,507586,380444,130714,1044407,396333,150984,670083,512135,232040,555499,463464,413939,218501,401609,966461,791596,131541,34608,598915,879434,486163,440348,90413,913686,954101,316206,1048068,839824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]