SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381581 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381581 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311484,379608,1031587,41731,625731,213074,395166,989741,275616,1020605,198560,936597,314220,935450,1041796,260474,828509,293147,334660,205541,434963,422095,911650,818992,538584,81006,850629,398432,405611,791845,617166,486226,75222,776953,605182,478435,392367,173059,781795,287730,908528,877040,916953,949693,206479,320045,426417,348344,726401,335634,26193,200915,996952,748010,826483,395218,118337,243807,398806,191330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]