SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003826s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010285 LIMIT 1 [ RunTime:0.002522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010285 [ RunTime:0.002992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481620,655724,856524,213862,484671,34933,965313,1033819,451811,270897,174217,755446,139249,387372,36581,252520,80749,459812,862840,419106,746427,514871,273199,466695,1014278,361979,614986,808818,620182,254872,638195,353952,676260,1022354,657342,386041,548661,1042344,842497,325094,708788,238114,57015,180528,147260,870193,1040688,59011,1012774,566779,383216,363444,1043022,47464,819730,107584,52205,950460,545155,826815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]