SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544723 LIMIT 1 [ RunTime:0.002827s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544723 [ RunTime:0.002824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894921,386344,465734,691105,237012,256,186085,248788,959818,448965,493298,843519,599930,510712,181232,843686,499069,198189,124972,985605,883159,17357,930017,891237,298923,302658,572060,356143,397603,638554,195132,805283,72777,313480,238959,597188,56306,905186,227613,463470,37337,237550,488591,355893,1000731,670907,366293,220780,236410,412192,944220,365283,316162,331021,394653,104371,899381,524496,905549,315045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]