SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505015 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505015 [ RunTime:0.001438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275430,252960,864158,995810,809481,135515,468576,770518,938801,819001,146987,686185,542275,615241,5783,210145,412142,816788,259665,245616,586846,362814,817382,56968,213669,787461,932952,918467,379895,94344,133234,570832,95890,757564,197276,326031,95583,88826,779530,254868,812433,53324,352606,515010,1012688,701873,370397,156179,655199,817363,203330,867837,963982,884553,394116,778675,875951,386565,122410,645155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]