SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509054 LIMIT 1 [ RunTime:0.002707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509054 [ RunTime:0.007129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684028,772872,5706,72618,699163,832209,378324,740602,682092,391316,178089,160676,245341,656740,712775,672835,576491,821320,626960,903551,453616,793993,98708,592764,645364,368061,821664,132128,153727,590627,673968,1017191,860291,831026,840035,704802,7682,982120,332408,492781,792826,201227,222061,917695,52476,251597,583036,770851,153043,523719,478446,829150,811338,692733,469890,911797,637674,955582,255254,97254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]