SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403241 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403241 [ RunTime:0.003429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190267,335656,396108,665794,951872,181527,334788,722643,234931,227447,923876,667442,151944,256519,981357,861008,339807,55718,484710,83633,1028716,231971,716319,805097,567513,521925,522851,626522,149857,883461,791245,47011,43581,620281,82765,994377,187613,517049,958799,712179,730037,672483,905770,708731,1036103,209395,458680,66949,971940,468803,769115,887182,566977,555501,957840,89487,470722,436111,17737,978330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]