SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001440 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001440 [ RunTime:0.013130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463935,1022489,405085,7712,1004803,978082,932587,661784,1037638,509792,613756,1031387,437615,695858,82078,848490,674028,697351,752174,838332,851883,973554,1034621,267569,886359,208970,723632,1020238,903270,681854,166203,165398,777144,90189,545351,648228,414657,988075,864592,962267,149449,1022023,1005407,713889,861267,874708,848943,378802,715725,441988,1035840,552591,435704,98731,692658,402551,113291,302301,762966,269038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]