SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 721183 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 721183 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741077,574137,443092,44810,994561,796929,825982,139477,870470,668015,484167,966527,308846,275463,697983,145070,192741,162910,283810,422536,295336,156181,922452,494968,594885,228712,460367,150999,150832,1971,852995,987579,314858,699686,163712,779769,630794,593267,1043498,665862,202550,362275,433025,629326,1029638,985893,386300,667192,161588,154072,257552,795620,194093,461163,161538,466938,532441,982126,990076,468571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 721183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 721183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]