SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415815 LIMIT 1 [ RunTime:0.003708s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415815 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559927,851998,170727,25117,948527,999289,804542,462050,296833,605563,110667,531420,637647,392605,394607,554759,463642,945846,367287,916739,562208,105168,331565,588209,747090,98344,662695,917891,528350,956329,1048682,802154,934662,904412,513140,956523,349604,482250,548488,346909,1043825,823431,297342,399193,223062,100102,788050,890249,685927,302355,968466,541582,603243,960821,520457,499019,220980,681671,704134,1036101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]