SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003580 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003580 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205278,306707,436164,909241,944494,36130,14563,196516,395343,177209,286108,334161,1039337,499157,883091,370060,815804,21611,295182,248133,447799,435274,777711,652923,849285,639858,775199,321095,653938,752718,756373,1021462,462242,754590,797160,551481,442492,645048,202389,389941,819182,340078,955539,383474,895358,935590,865834,465197,900630,711160,226525,463988,447069,903847,379983,167996,169425,528208,303551,676032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]