SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516823 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516823 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587657,630259,386467,977717,622344,657722,973998,826256,1036779,282652,931728,170321,477732,313838,679317,210323,352240,771970,120465,370753,207497,301747,20119,23117,917511,1023323,825999,500868,282288,577109,989127,612205,453227,167853,77048,16906,1000383,800741,573781,387456,799737,921072,573049,73840,600727,387757,814940,226965,714768,424516,355306,806825,104353,192921,468068,122986,35200,307576,659595,110136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]