SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014431 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014431 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979884,143597,526986,699746,433725,91497,214652,97449,847641,404391,973559,584741,317679,298365,331590,639187,727163,680268,164594,883776,30683,748077,94876,311160,989536,942032,1011920,337670,364841,103933,73575,576098,41466,626435,346534,979383,595048,211984,483696,1040026,255186,88625,507400,911173,594194,606536,707602,342867,3480,797065,1010777,123625,187063,471818,457956,982720,513451,963012,343101,263412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]