SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425029 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425029 [ RunTime:0.005067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637522,556334,98745,355436,683013,419542,855493,467706,657584,1024874,49494,651528,839620,999,737680,891519,201707,957,810894,899323,243596,580144,381517,755268,613408,920138,312790,71882,856774,968248,836923,39916,732708,672047,5853,828947,240575,300660,677702,579071,929925,637139,339089,949527,984988,309506,387859,87244,978110,449130,345160,664269,661749,671065,478237,748960,126292,809580,1000234,268059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]