SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 272845 LIMIT 1 [ RunTime:0.001363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 272845 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576441,297594,379879,195945,1034459,210905,254192,954477,278020,240782,890739,251431,7261,112620,314388,793529,102177,692224,129555,706612,106182,920744,792970,815729,274021,810582,366665,309032,926815,271252,426375,903806,959479,626860,600595,515846,503972,297510,1044587,633949,382238,118945,163583,272484,800425,379088,578311,501645,827036,10551,1001284,953721,811987,252950,143205,223302,268433,706794,181494,252027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 272845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 272845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]