SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482207 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482207 [ RunTime:0.003278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442615,416085,48425,11858,91374,287388,968778,353193,278315,851962,1001074,943964,332256,957646,173481,146245,696296,717795,1015903,924305,581004,264234,261515,349593,149992,722508,913477,630919,827578,492325,108396,313106,692495,317280,614824,397510,232751,367008,190656,547349,950427,211777,954996,802386,297149,849701,20692,145092,404479,660732,324094,483160,824771,716832,554734,1026836,416075,103420,345377,678102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003003s ]