SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149180 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149180 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301147,311501,785859,305824,510433,959117,134683,169126,389217,939226,34493,29561,946018,962348,602792,331633,895435,555919,349973,462381,612605,1002863,716318,338456,101718,132361,507265,704391,902744,211840,587780,446228,346109,906379,755449,403016,537991,460982,478346,659571,502440,915720,428320,876503,565505,495255,140747,817932,584126,207584,207118,470595,541502,869566,289666,846768,254021,181549,506417,111183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]