SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340448 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340448 [ RunTime:0.004449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417204,238662,237087,415609,888732,583904,156468,988375,926649,596794,102912,906410,234873,508201,931092,517320,80835,253341,339571,239214,905051,179433,862241,2804,66749,16661,433088,951046,431197,192802,501989,141424,399877,273848,453904,551896,767263,867340,532761,202242,33495,889151,94983,832262,819237,1023904,216653,804278,491495,77769,69296,932616,629314,844184,315042,647276,1031739,649646,381700,479991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]