SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801001 LIMIT 1 [ RunTime:0.000999s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801001 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880010,605178,908315,1025580,246885,297690,635721,426121,956833,898416,988695,51623,337944,135478,1001420,54605,544565,8287,844214,713624,476976,961296,101349,525419,714079,269565,612075,543854,1048826,524250,309745,66470,101051,36106,1041693,391220,219886,782881,753456,749340,272799,920492,910567,396183,445096,73234,114343,468185,23274,371739,371717,763480,969484,13301,701825,546328,894938,985589,695801,340362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001113s ]