SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 228101 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 228101 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401306,3610,306728,828621,436424,975819,402249,143171,264148,656429,394747,154117,110889,521232,653504,770752,501995,970634,294380,955488,540948,623496,898968,56795,172440,152438,373513,1002530,741425,1000131,834751,842065,902178,609599,947909,117205,955888,761012,747610,701359,781234,718863,111855,25791,213887,889504,887971,804793,449001,514430,372250,945533,150074,605002,981421,683102,211015,307710,330576,24368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 228101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 228101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]