SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174816 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174816 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412192,397018,137034,233063,782537,744504,289936,322016,721006,864619,191288,686674,388763,763694,361276,763392,130617,184583,110696,663756,828706,243220,217647,20936,1044430,775248,669046,162163,381374,306124,190433,459433,776413,303886,328163,720777,880232,187950,290893,728997,559865,879946,545767,164872,85895,234798,269479,439700,635175,999333,562436,101246,67170,939567,377571,824458,935289,1017261,849170,803657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]